/**
 * Created by guomin on 2017/4/28.
 */
var user={
    queryUserInfoByUid:"select u.id,u.name,u.mobile,u.address from wgy_users as u where u.id=? and u.type=1",
    queryUidByMobile:"select id from wgy_users where mobile=? and type=1",
    insertClaimant:"insert into wgy_users(type,mobile,name,address) value(1,?,?,?)",
    updateClaimant:"update wgy_users set address=? where id=?",
    //认领关系
    insertUserWish:"insert into wgy_user_wish(userid,wishid,status) value(?,?,1)"
};

exports=module.exports=user;